Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	1000000
Missing cells	285329
Missing cells (%)	1.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	122.1 MiB
Average record size in memory	128.0 B

Variable types

Numeric	9
Categorical	7

Alerts

`username` has a high cardinality: 4325 distinct values	High cardinality
`birth_date` has a high cardinality: 2440 distinct values	High cardinality
`title` has a high cardinality: 12529 distinct values	High cardinality
`genre` has a high cardinality: 4308 distinct values	High cardinality
`user_completed` is highly correlated with `user_days_spent_watching`	High correlation
`user_days_spent_watching` is highly correlated with `user_completed`	High correlation
`score` is highly correlated with `scored_by` and 2 other fields	High correlation
`scored_by` is highly correlated with `score` and 2 other fields	High correlation
`rank` is highly correlated with `score` and 2 other fields	High correlation
`popularity` is highly correlated with `score` and 2 other fields	High correlation
`user_completed` is highly correlated with `user_days_spent_watching`	High correlation
`user_days_spent_watching` is highly correlated with `user_completed`	High correlation
`score` is highly correlated with `rank` and 1 other fields	High correlation
`rank` is highly correlated with `score` and 1 other fields	High correlation
`popularity` is highly correlated with `score` and 1 other fields	High correlation
`user_completed` is highly correlated with `user_days_spent_watching`	High correlation
`user_days_spent_watching` is highly correlated with `user_completed`	High correlation
`score` is highly correlated with `rank`	High correlation
`scored_by` is highly correlated with `popularity`	High correlation
`rank` is highly correlated with `score`	High correlation
`popularity` is highly correlated with `scored_by`	High correlation
`my_score` is highly correlated with `score`	High correlation
`user_completed` is highly correlated with `user_days_spent_watching`	High correlation
`user_days_spent_watching` is highly correlated with `user_completed`	High correlation
`type` is highly correlated with `source`	High correlation
`source` is highly correlated with `type`	High correlation
`score` is highly correlated with `my_score` and 2 other fields	High correlation
`rank` is highly correlated with `score` and 1 other fields	High correlation
`popularity` is highly correlated with `score` and 1 other fields	High correlation
`birth_date` has 262229 (26.2%) missing values	Missing
`rank` has 23100 (2.3%) missing values	Missing
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`my_score` has 155395 (15.5%) zeros	Zeros

Reproduction

Analysis started	2021-11-16 10:05:03.271582
Analysis finished	2021-11-16 10:06:09.281509
Duration	1 minute and 6.01 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	1000000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	500114.282

Minimum	0
Maximum	1000221
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	50004.95
Q1	250067.75
median	500115.5
Q3	750156.25
95-th percentile	950218.05
Maximum	1000221
Range	1000221
Interquartile range (IQR)	500088.5

Descriptive statistics

Standard deviation	288731.5432
Coefficient of variation (CV)	0.5773311293
Kurtosis	-1.199960846
Mean	500114.282
Median Absolute Deviation (MAD)	250044.5
Skewness	1.449976156 × 10^-5
Sum	5.00114282 × 10¹¹
Variance	8.336590402 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
239904	1	< 0.1%
153886	1	< 0.1%
147741	1	< 0.1%
149788	1	< 0.1%
160027	1	< 0.1%
162074	1	< 0.1%
155929	1	< 0.1%
157976	1	< 0.1%
135447	1	< 0.1%
Other values (999990)	999990	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
1000221	1	< 0.1%
1000220	1	< 0.1%
1000219	1	< 0.1%
1000218	1	< 0.1%
1000217	1	< 0.1%
1000216	1	< 0.1%
1000215	1	< 0.1%
1000214	1	< 0.1%
1000213	1	< 0.1%
1000212	1	< 0.1%

username
Categorical

HIGH CARDINALITY

Distinct	4325
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

MugenDreamu	5656
Pullman	4149
MistButterfly	3988
Jay-kun	3562
purplepinapples	3281
Other values (4320)	979364

Length

Max length	16
Median length	9
Mean length	8.94287
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	< 0.1%

Sample

1st row	karthiga
2nd row	karthiga
3rd row	karthiga
4th row	karthiga
5th row	karthiga

Common Values

Value	Count	Frequency (%)
MugenDreamu	5656	0.6%
Pullman	4149	0.4%
MistButterfly	3988	0.4%
Jay-kun	3562	0.4%
purplepinapples	3281	0.3%
sprite1989	2682	0.3%
Myorave	2356	0.2%
AnimeKami	2310	0.2%
soccerscot15	2219	0.2%
-Ackerman	2204	0.2%
Other values (4315)	967593	96.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mugendreamu	5656	0.6%
pullman	4149	0.4%
mistbutterfly	3988	0.4%
jay-kun	3562	0.4%
purplepinapples	3281	0.3%
sprite1989	2682	0.3%
myorave	2356	0.2%
animekami	2310	0.2%
soccerscot15	2219	0.2%
ackerman	2204	0.2%
Other values (4315)	967593	96.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

anime_id
Real number (ℝ_≥0)

Distinct	12530
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10857.32272

Minimum	1
Maximum	37877
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1
5-th percentile	145
Q1	1535
median	6862
Q3	17729
95-th percentile	32983
Maximum	37877
Range	37876
Interquartile range (IQR)	16194

Descriptive statistics

Standard deviation	10967.67552
Coefficient of variation (CV)	1.010163905
Kurtosis	-0.4652558961
Mean	10857.32272
Median Absolute Deviation (MAD)	6064
Skewness	0.9087388412
Sum	1.085732272 × 10¹⁰
Variance	120289906.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1535	2924	0.3%
1575	2362	0.2%
199	2207	0.2%
226	2159	0.2%
16498	2125	0.2%
2904	2087	0.2%
4224	2076	0.2%
11757	2056	0.2%
121	2051	0.2%
6547	2051	0.2%
Other values (12520)	977902	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1492	0.1%
5	741	0.1%
6	1082	0.1%
7	326	< 0.1%
8	49	< 0.1%
15	281	< 0.1%
16	568	0.1%
17	85	< 0.1%
18	241	< 0.1%
19	678	0.1%

Value	Count	Frequency (%)
37877	1	< 0.1%
37875	1	< 0.1%
37867	1	< 0.1%
37854	1	< 0.1%
37853	1	< 0.1%
37845	1	< 0.1%
37825	1	< 0.1%
37801	1	< 0.1%
37792	1	< 0.1%
37790	1	< 0.1%

my_score
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.333114

Minimum	0
Maximum	10
Zeros	155395
Zeros (%)	15.5%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	7
Q3	8
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.135274612
Coefficient of variation (CV)	0.4950605045
Kurtosis	-0.05730720258
Mean	6.333114
Median Absolute Deviation (MAD)	1
Skewness	-1.060830093
Sum	6333114
Variance	9.829946893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
8	208140	20.8%
7	192612	19.3%
0	155395	15.5%
9	143384	14.3%
6	105043	10.5%
10	99906	10.0%
5	52298	5.2%
4	22587	2.3%
3	10602	1.1%
2	6259	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	155395	15.5%
1	3774	0.4%
2	6259	0.6%
3	10602	1.1%
4	22587	2.3%
5	52298	5.2%
6	105043	10.5%
7	192612	19.3%
8	208140	20.8%
9	143384	14.3%

Value	Count	Frequency (%)
10	99906	10.0%
9	143384	14.3%
8	208140	20.8%
7	192612	19.3%
6	105043	10.5%
5	52298	5.2%
4	22587	2.3%
3	10602	1.1%
2	6259	0.6%
1	3774	0.4%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Male	712984
Female	287016

Length

Max length	6
Median length	4
Mean length	4.574032
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Female
5th row	Female

Common Values

Value	Count	Frequency (%)
Male	712984	71.3%
Female	287016	28.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
male	712984	71.3%
female	287016	28.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

user_completed
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	798
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	579.644442

Minimum	0
Maximum	5674
Zeros	1238
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	67
Q1	194
median	362
Q3	696
95-th percentile	1766
Maximum	5674
Range	5674
Interquartile range (IQR)	502

Descriptive statistics

Standard deviation	700.7791147
Coefficient of variation (CV)	1.208980996
Kurtosis	19.58249895
Mean	579.644442
Median Absolute Deviation (MAD)	211
Skewness	3.765226088
Sum	579644442
Variance	491091.3677
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5674	5656	0.6%
102	4955	0.5%
217	4248	0.4%
4137	4149	0.4%
3923	3988	0.4%
3284	3562	0.4%
349	3431	0.3%
2898	3281	0.3%
265	3065	0.3%
568	3005	0.3%
Other values (788)	960660	96.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1238	0.1%
1	109	< 0.1%
2	127	< 0.1%
3	143	< 0.1%
4	197	< 0.1%
5	259	< 0.1%
6	171	< 0.1%
7	236	< 0.1%
8	293	< 0.1%
9	362	< 0.1%

Value	Count	Frequency (%)
5674	5656	0.6%
4137	4149	0.4%
3923	3988	0.4%
3284	3562	0.4%
2898	3281	0.3%
2346	2356	0.2%
2298	2310	0.2%
2189	2219	0.2%
2176	2204	0.2%
2082	2082	0.2%

user_days_spent_watching
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3770
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	165.5766863

Minimum	0
Maximum	3185.71
Zeros	11
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	0
5-th percentile	26.44
Q1	67.3
median	116
Q3	191.93
95-th percentile	413.88
Maximum	3185.71
Range	3185.71
Interquartile range (IQR)	124.63

Descriptive statistics

Standard deviation	257.5896632
Coefficient of variation (CV)	1.555712153
Kurtosis	104.3334158
Mean	165.5766863
Median Absolute Deviation (MAD)	57.24
Skewness	9.289707037
Sum	165576686.3
Variance	66352.43457
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3185.71	5656	0.6%
453.05	4149	0.4%
614.96	3988	0.4%
242.86	3985	0.4%
494.97	3562	0.4%
30.86	2682	0.3%
421.93	2356	0.2%
416.89	2310	0.2%
141.54	2309	0.2%
493.01	2219	0.2%
Other values (3760)	966784	96.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11	< 0.1%
0.03	1	< 0.1%
0.05	5	< 0.1%
0.06	9	< 0.1%
0.08	1131	0.1%
0.09	47	< 0.1%
0.11	2	< 0.1%
0.14	1	< 0.1%
0.19	3	< 0.1%
0.2	2	< 0.1%

Value	Count	Frequency (%)
3185.71	5656	0.6%
1332.14	192	< 0.1%
919.01	1708	0.2%
813.6	1951	0.2%
720.36	645	0.1%
698.51	16	< 0.1%
636.09	100	< 0.1%
614.96	3988	0.4%
590.1	354	< 0.1%
587.09	1757	0.2%

birth_date
Categorical

HIGH CARDINALITY
MISSING

Distinct	2440
Distinct (%)	0.3%
Missing	262229
Missing (%)	26.2%
Memory size	7.6 MiB

1991-01-01	5368
1992-01-16	4310
1989-10-22	4149
1989-07-29	3107
1994-01-01	3040
Other values (2435)	717797

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	1990-04-29
2nd row	1990-04-29
3rd row	1990-04-29
4th row	1990-04-29
5th row	1990-04-29

Common Values

Value	Count	Frequency (%)
1991-01-01	5368	0.5%
1992-01-16	4310	0.4%
1989-10-22	4149	0.4%
1989-07-29	3107	0.3%
1994-01-01	3040	0.3%
1989-01-01	2633	0.3%
1993-12-28	2550	0.3%
1995-01-01	2514	0.3%
1988-01-01	2452	0.2%
1992-05-14	2259	0.2%
Other values (2430)	705389	70.5%
(Missing)	262229	26.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1991-01-01	5368	0.7%
1992-01-16	4310	0.6%
1989-10-22	4149	0.6%
1989-07-29	3107	0.4%
1994-01-01	3040	0.4%
1989-01-01	2633	0.4%
1993-12-28	2550	0.3%
1995-01-01	2514	0.3%
1988-01-01	2452	0.3%
1992-05-14	2259	0.3%
Other values (2430)	705389	95.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

title
Categorical

HIGH CARDINALITY

Distinct	12529
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Death Note	2924
Code Geass: Hangyaku no Lelouch	2362
Sen to Chihiro no Kamikakushi	2207
Elfen Lied	2159
Shingeki no Kyojin	2125
Other values (12524)	988223

Length

Max length	100
Median length	20
Mean length	23.423018
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1893 ?
Unique (%)	0.2%

Sample

1st row	One Piece
2nd row	Chobits
3rd row	Gakuen Alice
4th row	Fruits Basket
5th row	Ultra Maniac

Common Values

Value	Count	Frequency (%)
Death Note	2924	0.3%
Code Geass: Hangyaku no Lelouch	2362	0.2%
Sen to Chihiro no Kamikakushi	2207	0.2%
Elfen Lied	2159	0.2%
Shingeki no Kyojin	2125	0.2%
Code Geass: Hangyaku no Lelouch R2	2087	0.2%
Toradora!	2076	0.2%
Sword Art Online	2056	0.2%
Fullmetal Alchemist	2051	0.2%
Angel Beats!	2051	0.2%
Other values (12519)	977902	97.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
no	280267	7.4%
the	60685	1.6%
to	49428	1.3%
movie	42350	1.1%
ga	35934	1.0%
wa	33776	0.9%
	32584	0.9%
ni	27574	0.7%
of	24807	0.7%
2	20916	0.6%
Other values (13134)	3169876	83.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

type
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

TV	629300
Movie	137701
OVA	121403
Special	83600
ONA	19228

Length

Max length	7
Median length	2
Mean length	2.998038
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TV
2nd row	TV
3rd row	TV
4th row	TV
5th row	TV

Common Values

Value	Count	Frequency (%)
TV	629300	62.9%
Movie	137701	13.8%
OVA	121403	12.1%
Special	83600	8.4%
ONA	19228	1.9%
Music	8768	0.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
tv	629300	62.9%
movie	137701	13.8%
ova	121403	12.1%
special	83600	8.4%
ona	19228	1.9%
music	8768	0.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

source
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Manga	413257
Original	182785
Light novel	153030
Visual novel	69260
Unknown	48653
Other values (11)	133015

Length

Max length	13
Median length	5
Mean length	7.281572
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manga
2nd row	Manga
3rd row	Manga
4th row	Manga
5th row	Manga

Common Values

Value	Count	Frequency (%)
Manga	413257	41.3%
Original	182785	18.3%
Light novel	153030	15.3%
Visual novel	69260	6.9%
Unknown	48653	4.9%
Novel	35551	3.6%
Game	35450	3.5%
4-koma manga	28572	2.9%
Web manga	13778	1.4%
Other	11229	1.1%
Other values (6)	8435	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
manga	456086	36.0%
novel	257841	20.3%
original	182785	14.4%
light	153030	12.1%
visual	69260	5.5%
unknown	48653	3.8%
game	37502	3.0%
4-koma	28572	2.3%
web	13778	1.1%
other	11229	0.9%
Other values (6)	8865	0.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	609
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5121052

Minimum	1.9
Maximum	9.25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1.9
5-th percentile	6.22
Q1	7.11
median	7.56
Q3	8.04
95-th percentile	8.59
Maximum	9.25
Range	7.35
Interquartile range (IQR)	0.93

Descriptive statistics

Standard deviation	0.7661365442
Coefficient of variation (CV)	0.1019869296
Kurtosis	2.942844054
Mean	7.5121052
Median Absolute Deviation (MAD)	0.47
Skewness	-0.9603056362
Sum	7512105.2
Variance	0.5869652043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.75	12284	1.2%
8.21	9175	0.9%
7.41	9028	0.9%
7.88	8865	0.9%
7.4	8698	0.9%
7.89	8678	0.9%
7.42	8608	0.9%
7.45	8400	0.8%
7.83	8373	0.8%
8.29	7940	0.8%
Other values (599)	909951	91.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.9	83	< 0.1%
2.08	55	< 0.1%
2.33	266	< 0.1%
2.38	17	< 0.1%
2.44	1	< 0.1%
2.52	36	< 0.1%
2.55	1	< 0.1%
2.57	1	< 0.1%
2.6	12	< 0.1%
2.61	17	< 0.1%

Value	Count	Frequency (%)
9.25	2012	0.2%
9.19	1120	0.1%
9.15	572	0.1%
9.14	1744	0.2%
9.11	1646	0.2%
9.1	174	< 0.1%
9.07	323	< 0.1%
9.04	1056	0.1%
9.02	350	< 0.1%
9.01	2363	0.2%

scored_by
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	5906
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	112159.5922

Minimum	1
Maximum	1009477
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1716
Q1	17032
median	53999
Q3	142516
95-th percentile	433097
Maximum	1009477
Range	1009476
Interquartile range (IQR)	125484

Descriptive statistics

Standard deviation	152686.8764
Coefficient of variation (CV)	1.361335872
Kurtosis	8.078199207
Mean	112159.5922
Median Absolute Deviation (MAD)	44896
Skewness	2.550230367
Sum	1.121595922 × 10¹¹
Variance	2.331328221 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1009477	2924	0.3%
627740	2362	0.2%
498602	2207	0.2%
514656	2159	0.2%
940211	2125	0.2%
543904	2087	0.2%
557898	2076	0.2%
915986	2056	0.2%
641851	2051	0.2%
491403	2051	0.2%
Other values (5896)	977902	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	< 0.1%
2	4	< 0.1%
3	20	< 0.1%
4	17	< 0.1%
5	41	< 0.1%
6	55	< 0.1%
7	65	< 0.1%
8	87	< 0.1%
9	85	< 0.1%
10	87	< 0.1%

Value	Count	Frequency (%)
1009477	2924	0.3%
940211	2125	0.2%
915986	2056	0.2%
733592	2012	0.2%
691845	1526	0.2%
659308	1467	0.1%
648605	2042	0.2%
641851	2051	0.2%
627740	2362	0.2%
623227	1404	0.1%

rank
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	9348
Distinct (%)	1.0%
Missing	23100
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	2091.111767

Minimum	1
Maximum	12857
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1
5-th percentile	68
Q1	486
median	1419
Q3	3059
95-th percentile	6529
Maximum	12857
Range	12856
Interquartile range (IQR)	2573

Descriptive statistics

Standard deviation	2081.416661
Coefficient of variation (CV)	0.9953636595
Kurtosis	2.024101947
Mean	2091.111767
Median Absolute Deviation (MAD)	1094
Skewness	1.459756785
Sum	2042807085
Variance	4332295.315
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
247	3726	0.4%
51	2924	0.3%
30	2362	0.2%
560	2226	0.2%
19	2207	0.2%
1259	2175	0.2%
823	2175	0.2%
573	2167	0.2%
982	2159	0.2%
110	2125	0.2%
Other values (9338)	952654	95.3%
(Missing)	23100	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2012	0.2%
2	1120	0.1%
3	301	< 0.1%
4	271	< 0.1%
5	1744	0.2%
6	218	< 0.1%
7	451	< 0.1%
8	977	0.1%
9	174	< 0.1%
10	323	< 0.1%

Value	Count	Frequency (%)
12857	4	< 0.1%
12856	2	< 0.1%
12855	2	< 0.1%
12854	1	< 0.1%
12852	3	< 0.1%
12851	1	< 0.1%
12849	1	< 0.1%
12848	1	< 0.1%
12847	1	< 0.1%
12846	1	< 0.1%

popularity
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10381
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1441.811542

Minimum	1
Maximum	14484
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1
5-th percentile	30
Q1	250
median	789
Q3	1893.25
95-th percentile	5192
Maximum	14484
Range	14483
Interquartile range (IQR)	1643.25

Descriptive statistics

Standard deviation	1834.165217
Coefficient of variation (CV)	1.272125492
Kurtosis	8.438225745
Mean	1441.811542
Median Absolute Deviation (MAD)	650
Skewness	2.542115478
Sum	1441811542
Variance	3364162.042
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2924	0.3%
94	2379	0.2%
9	2362	0.2%
39	2207	0.2%
16	2159	0.2%
240	2141	0.2%
2	2125	0.2%
129	2090	0.2%
22	2087	0.2%
13	2076	0.2%
Other values (10371)	977450	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2924	0.3%
2	2125	0.2%
3	2056	0.2%
4	2012	0.2%
5	1526	0.2%
6	1467	0.1%
7	2051	0.2%
8	1744	0.2%
9	2362	0.2%
10	2042	0.2%

Value	Count	Frequency (%)
14484	1	< 0.1%
14477	1	< 0.1%
14475	1	< 0.1%
14466	1	< 0.1%
14465	1	< 0.1%
14464	1	< 0.1%
14463	1	< 0.1%
14460	1	< 0.1%
14458	1	< 0.1%
14453	1	< 0.1%

genre
Categorical

HIGH CARDINALITY

Distinct	4308
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Hentai	12997
Comedy	8611
Slice of Life, Comedy	5894
Slice of Life, Comedy, School	5434
Music	5214
Other values (4303)	961850

Length

Max length	125
Median length	37
Mean length	37.582888
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	230 ?
Unique (%)	< 0.1%

Sample

1st row	Action, Adventure, Comedy, Super Power, Drama, Fantasy, Shounen
2nd row	Sci-Fi, Comedy, Drama, Romance, Ecchi, Seinen
3rd row	Comedy, School, Shoujo, Super Power
4th row	Slice of Life, Comedy, Drama, Romance, Fantasy, Shoujo
5th row	Magic, Comedy, Romance, School, Shoujo

Common Values

Value	Count	Frequency (%)
Hentai	12997	1.3%
Comedy	8611	0.9%
Slice of Life, Comedy	5894	0.6%
Slice of Life, Comedy, School	5434	0.5%
Music	5214	0.5%
Slice of Life, Comedy, Romance, School	5005	0.5%
Action, Supernatural, Magic, Fantasy	4847	0.5%
Comedy, Romance, School	4225	0.4%
Comedy, Romance, School, Shounen	3852	0.4%
Action, Sci-Fi, Adventure, Comedy, Fantasy, Shounen	3807	0.4%
Other values (4298)	940114	94.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
comedy	493421	10.3%
action	390996	8.2%
romance	299107	6.2%
drama	281460	5.9%
fantasy	246955	5.2%
shounen	235599	4.9%
school	232758	4.9%
supernatural	231859	4.8%
adventure	209332	4.4%
sci-fi	197956	4.1%
Other values (36)	1971975	41.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	username	anime_id	my_score	gender	user_completed	user_days_spent_watching	birth_date	title	type	source	score	scored_by	rank	popularity	genre
0	0	karthiga	21	9	Female	49	55.31	1990-04-29	One Piece	TV	Manga	8.54	423868.0	91.0	35.0	Action, Adventure, Comedy, Super Power, Drama, Fantasy, Shounen
1	1	karthiga	59	7	Female	49	55.31	1990-04-29	Chobits	TV	Manga	7.53	175388.0	1546.0	188.0	Sci-Fi, Comedy, Drama, Romance, Ecchi, Seinen
2	2	karthiga	74	7	Female	49	55.31	1990-04-29	Gakuen Alice	TV	Manga	7.77	33244.0	941.0	1291.0	Comedy, School, Shoujo, Super Power
3	3	karthiga	120	7	Female	49	55.31	1990-04-29	Fruits Basket	TV	Manga	7.77	167968.0	939.0	222.0	Slice of Life, Comedy, Drama, Romance, Fantasy, Shoujo
4	4	karthiga	178	7	Female	49	55.31	1990-04-29	Ultra Maniac	TV	Manga	7.26	9663.0	2594.0	2490.0	Magic, Comedy, Romance, School, Shoujo
5	5	karthiga	210	7	Female	49	55.31	1990-04-29	Ranma ½	TV	Manga	7.85	59911.0	802.0	623.0	Slice of Life, Comedy, Martial Arts, Fantasy
6	6	karthiga	232	6	Female	49	55.31	1990-04-29	Cardcaptor Sakura	TV	Manga	8.21	121898.0	297.0	292.0	Adventure, Comedy, Drama, Magic, Romance, Fantasy, School, Shoujo
7	7	karthiga	233	6	Female	49	55.31	1990-04-29	Daa! Daa! Daa!	TV	Manga	7.78	6598.0	919.0	3045.0	Comedy, Sci-Fi, Shoujo
8	8	karthiga	249	8	Female	49	55.31	1990-04-29	InuYasha	TV	Manga	7.90	181978.0	697.0	141.0	Action, Adventure, Comedy, Historical, Demons, Supernatural, Magic, Romance, Fantasy, Shounen
9	9	karthiga	269	10	Female	49	55.31	1990-04-29	Bleach	TV	Manga	7.90	433097.0	693.0	18.0	Action, Adventure, Comedy, Super Power, Supernatural, Shounen

Last rows

	df_index	username	anime_id	my_score	gender	user_completed	user_days_spent_watching	birth_date	title	type	source	score	scored_by	rank	popularity	genre
999990	1000212	Sarovoc	23281	7	Male	393	130.75	1986-02-06	Psycho-Pass 2	TV	Original	7.54	173042.0	1533.0	180.0	Action, Sci-Fi, Police, Psychological
999991	1000213	Sarovoc	23327	6	Male	393	130.75	1986-02-06	Space☆Dandy 2nd Season	TV	Original	8.28	44045.0	260.0	992.0	Space, Comedy, Sci-Fi
999992	1000214	Sarovoc	23755	9	Male	393	130.75	1986-02-06	Nanatsu no Taizai	TV	Manga	8.29	385532.0	251.0	52.0	Action, Adventure, Supernatural, Magic, Ecchi, Fantasy, Shounen
999993	1000215	Sarovoc	23775	7	Male	393	130.75	1986-02-06	Shingeki no Kyojin Movie 1: Guren no Yumiya	Movie	Manga	7.69	18325.0	1139.0	1580.0	Action, Drama, Fantasy, Shounen, Super Power
999994	1000216	Sarovoc	23777	7	Male	393	130.75	1986-02-06	Shingeki no Kyojin Movie 2: Jiyuu no Tsubasa	Movie	Manga	7.76	13153.0	974.0	1703.0	Action, Super Power, Drama, Fantasy, Shounen
999995	1000217	Sarovoc	24029	8	Male	393	130.75	1986-02-06	Shijou Saikyou no Deshi Kenichi Specials	Special	Manga	7.40	2500.0	2043.0	4420.0	Action, Martial Arts, Comedy, School, Shounen
999996	1000218	Sarovoc	24439	7	Male	393	130.75	1986-02-06	Kekkai Sensen	TV	Manga	7.73	166813.0	1041.0	142.0	Action, Comedy, Super Power, Supernatural, Vampire, Fantasy, Shounen
999997	1000219	Sarovoc	24627	7	Male	393	130.75	1986-02-06	Yamada-kun to 7-nin no Majo (OVA)	OVA	Manga	7.58	25763.0	1418.0	1545.0	Comedy, Romance, School, Shounen
999998	1000220	Sarovoc	24703	8	Male	393	130.75	1986-02-06	High School DxD BorN	TV	Light novel	7.68	191936.0	1148.0	189.0	Action, Comedy, Demons, Ecchi, Harem, Romance, School
999999	1000221	Sarovoc	24833	8	Male	393	130.75	1986-02-06	Ansatsu Kyoushitsu	TV	Manga	8.22	313058.0	289.0	59.0	Action, Comedy, School, Shounen

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows